COURSE INTRODUCTION AND APPLICATION INFORMATION

Course Name
Database and Management
Code
Semester
Theory
(hour/week)
Application/Lab
(hour/week)
Local Credits
ECTS
MBP 203
Fall
2
2
3
5
Prerequisites
None
Course Language
Turkish
Course Type
Required
Course Level
Short Cycle
Mode of Delivery -
Teaching Methods and Techniques of the Course
Course Coordinator -
Course Lecturer(s)
Assistant(s) -
Course Objectives The aim of this course is to provide students a deep knowledge and experience in database design, management and programming topics.
Learning Outcomes The students who succeeded in this course;
  • Will be able to get knowledge of database design, administration, query and implementation
  • Will be able to have the infrastructure required for large-scale data and database administration
  • Will be able to have knowledge about data grouping, filtering
  • Will be able to interpret data types
  • Will be able to get knowledge on SQL
  • Will be able to comprehend data grouping, filtering
Course Description The content of this course includes entity-relationship database model, functional dependencies, primary key concept and also practical table creation, update and deletion processes in database server.
Related Sustainable Development Goals

 



Course Category

 Core Courses
X
Major Area Courses
Supportive Courses
Media and Managment Skills Courses
Transferable Skill Courses

 

WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES

Week Subjects Required Materials
1 Introduction to Database Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 1
2 Introduction to SQL Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 1
3 Data Types Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 1
4 Table Creation Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 6
5 Table Creation 2 Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 6
6 Relational Database Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 2
7 Relational Database 2 Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 2
8 Midterm
9 Data Grouping Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 8
10 Data Grouping 2 Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 8
11 Data Filtering Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 9
12 Table Update Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 9
13 Advanced Projects Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 10
14 Reporting Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 11
15 Report Formatting Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015) Part 11
16 Final
Course Notes/Textbooks

Özseven, T., "Veritabanı Yönetim Sistemleri 1", Ekim Basım Yayın (2015). ISBN: 9786053271574
Suggested Readings/Materials

 

EVALUATION SYSTEM

Semester Activities Number Weigthing
Participation
1
8
Laboratory / Application
Field Work
Quizzes / Studio Critiques
Portfolio
Homework / Assignments
Presentation / Jury
Project
Seminar / Workshop
1
12
Oral Exam
Midterm
1
35
Final Exam
1
45
Total

Weighting of Semester Activities on the Final Grade
2
50
Weighting of End-of-Semester Activities on the Final Grade
1
50
Total

ECTS / WORKLOAD TABLE

Semester Activities Number Duration (Hours) Workload
Course Hours
(Including exam week: 16 x total hours)
16
2
32
Laboratory / Application Hours
(Including exam week: 16 x total hours)
16
2
Study Hours Out of Class
16
3
48
Field Work
Quizzes / Studio Critiques
Portfolio
Homework / Assignments
Presentation / Jury
Project
Seminar / Workshop
1
6
Oral Exam
Midterms
1
10
Final Exams
1
16
    Total
144

 

COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP

#
 Program Competencies/Outcomes
* Contribution Level
1
2
3
4
5
1

To be able to have basic computer hardware and software knowledge.

 X
2

To be able to develop the necessary applications by using internet and network technologies.

 X
3

To follow developments in the field to adapt to changing conditions.

 X
4

To be able to conduct experiments in the field and analyze the results.

 X
5

To be able to use basic programming languages related to the field.

 X
6

To be able to design and install a computer system that includes software, hardware, or both, meeting the basic needs of the field.

 X
7

To be able to interpret and follow current developments in the field of computer programming.

 X
8

To be able to carry professional and ethical responsibility and have awareness of professional ethics in their practices.

 X
9

To have basic theoretical and practical knowledge about mathematics, computing and computer science.
10

To be able to follow the information in the field and communicate with colleagues by using English at the general level of European Language Portfolio A2.
11

To be able to direct his/her education to a further level of education

*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest